Hệ thống quản lý phương tiện trong PHP
1 <?php
2
3 $connection= mysqli_connect("localhost","root","","vehiclemanagement");
4 session_start();
5
6 $id= $_GET['id'];
7
8 $sql= "SELECT * FROM `booking` WHERE booking_id='$id'";
9
10 //echo $sql;
11 $res= mysqli_query($connection,$sql);
12 $row= mysqli_fetch_assoc($res);
13
14 if(isset($_POST['email'])) {
15
16
17
18 // EDIT THE 2 LINES BELOW AS REQUIRED
19
20 $email_to = $row['email'];
21
22 //echo $email_to;
23
24
25
26
27
28
29
30
31
32
33 // validation expected data exists
34 /*
35 if(!isset($_POST['first_name']) ||
36
37 // !isset($_POST['last_name']) ||
38
39 !isset($_POST['email']) ||
40
41 !isset($_POST['phone']) ||
42
43 !isset($_POST['comment'])) {
44
45 died(''); //enter msg within this string
46
47 }*/
48
49
50
51 $first_name = $row['name']; // required
52
53 // $last_name = $_POST['last_name']; // required
54
55 $email_from = "iafbd24@gmail.com"; // required
56
57 $telephone = $row['mobile']; // not required
58
59 //$comments = $_POST['comment']; // required
60 $driver_id= $_POST['driverid'];
61 //echo $driver_id;
62
63 $veh_reg= $_POST['veh_reg'];
64 //$veh_reg= $_POST[''];
65 //echo $veh_reg;
66
67 $sql2="SELECT * FROM `driver` WHERE driverid='$driver_id'";
68 $res2= mysqli_query($connection,$sql2);
69 $row2= mysqli_fetch_assoc($res2);
70
71 $driver_name=$row2['drname'];
72 $driver_mobile=$row2['drmobile'];
73 //echo $driver_name;
74 //echo $driver_mobile;
75
76
77
78
79 $email_message = " This is an email form RUET Vehicle Management to confirm your vehicle. Details are given below.\n\n";
80
81
82
83 function clean_string($string) {
84
85 $bad = array("content-type","bcc:","to:","cc:","href");
86
87 return str_replace($bad,"",$string);
88
89 }
90
91
92
93 $email_message .= "first Name: ".clean_string($first_name)."\n";
94
95 // $email_message .= "Last Name: ".clean_string($last_name)."\n";
96
97 $email_message .= "Email: ".clean_string($email_from)."\n";
98
99 $email_message .= "Phone: ".clean_string($telephone)."\n\n";
100
101 $email_message .= "Driver's Name: ".clean_string($driver_name)."\n";
102 $email_message .= "Vehicle Regitration: ".clean_string($veh_reg)."\n";
103 $email_message .= "Driver's Phone Number: ".clean_string($driver_mobile)."\n";
104
105
106
107
108
109 // create email headers
110
111 $headers = 'From: '.$email_from."\r\n".
112
113 'Reply-To: '.$email_from."\r\n" .
114
115 'X-Mailer: PHP/' . phpversion();
116
117 @mail($email_to, $email_subject, $email_message, $headers);
118
119
120 $update_query="UPDATE `booking` SET `confirmation`='1',`veh_reg`='$veh_reg',`driverid`='$driver_id' WHERE booking_id='$id'; UPDATE `vehicle` SET `veh_available`='1' WHERE veh_reg='$veh_reg';UPDATE `driver` SET `dr_available`='1' WHERE driverid='$driver_id'";
121
122 //$update_query="UPDATE `booking` SET `confirmation`='1' WHERE booking_id='$id'";
123 //echo $update_query;
124
125
126
127 //$res3=mysqli_query($connection,$update_query);
128 $res3=mysqli_multi_query($connection,$update_query); //to run multiple query
129
130 ?>
131
132 <!DOCTYPE html>
133 <html lang="en">
134 <head>
135 <meta charset="UTF-8">
136 <title>success</title>
137 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
138 <link rel="stylesheet" href="animate.css">
139 <link rel="stylesheet" href="style.css">
140 </head>
141 <body>
142 <?php include 'navbar_admin.php'; ?>
143 <div class="container">
144 <div class="row">
145 <div class="col-md-3"></div>
146 <div class="col-md-6">
147 <br><br><br><br><br>
148 <div class="alert alert-success animated tada">
149 <strong>Success!</strong> Mail has been sent successfully.
150 </div>
151
152 <a class="btn btn-default" href="bookinglist.php">Go Back</a>
153 </div>
154 <div class="col-md-3"></div>
155 </div>
156 </div>
157
158 </body>
159 </html>
160
161
162
163 <?php
164
165 }
166
167 ?>